<?xml version="1.0" encoding="utf-8"?>
<xs:schema xmlns:tns="http://schemas.datacontract.org/2004/07/WCFServiceImplementation" elementFormDefault="qualified" targetNamespace="http://schemas.datacontract.org/2004/07/WCFServiceImplementation" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:import schemaLocation="http://localhost/advantage555/VAdvantageSvc/ExcelImportService.svc?xsd=xsd3" namespace="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
  <xs:complexType name="ExcelMapping">
    <xs:sequence>
      <xs:element minOccurs="0" name="AD_Window_ID" type="xs:int" />
      <xs:element xmlns:q1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" minOccurs="0" name="CtxDic" nillable="true" type="q1:ArrayOfKeyValueOfstringstring" />
      <xs:element minOccurs="0" name="DoCommit" type="xs:boolean" />
      <xs:element xmlns:q2="http://schemas.microsoft.com/2003/10/Serialization/Arrays" minOccurs="0" name="ExcelCol" nillable="true" type="q2:ArrayOfstring" />
      <xs:element minOccurs="0" name="ExcelMapping_ID" type="xs:int" />
      <xs:element minOccurs="0" name="FileName" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="MappingName" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="TabDetail" nillable="true" type="tns:ArrayOfExcelMappingPerTabDetail" />
    </xs:sequence>
  </xs:complexType>
  <xs:element name="ExcelMapping" nillable="true" type="tns:ExcelMapping" />
  <xs:complexType name="ArrayOfExcelMappingPerTabDetail">
    <xs:sequence>
      <xs:element minOccurs="0" maxOccurs="unbounded" name="ExcelMappingPerTabDetail" nillable="true" type="tns:ExcelMappingPerTabDetail" />
    </xs:sequence>
  </xs:complexType>
  <xs:element name="ArrayOfExcelMappingPerTabDetail" nillable="true" type="tns:ArrayOfExcelMappingPerTabDetail" />
  <xs:complexType name="ExcelMappingPerTabDetail">
    <xs:sequence>
      <xs:element minOccurs="0" name="AD_Tab_ID" type="xs:int" />
      <xs:element minOccurs="0" name="AD_Table_ID" type="xs:int" />
      <xs:element xmlns:q3="http://schemas.microsoft.com/2003/10/Serialization/Arrays" minOccurs="0" name="AllColumns" nillable="true" type="q3:ArrayOfKeyValueOfintstring" />
      <xs:element minOccurs="0" name="ColumnDetail" nillable="true" type="tns:ArrayOfExcelMappingDetail" />
      <xs:element minOccurs="0" name="IsLocationMapped" type="xs:boolean" />
      <xs:element minOccurs="0" name="LocationMapping" nillable="true" type="tns:ArrayOfExcelMappingDetail" />
      <xs:element minOccurs="0" name="TableName" nillable="true" type="xs:string" />
    </xs:sequence>
  </xs:complexType>
  <xs:element name="ExcelMappingPerTabDetail" nillable="true" type="tns:ExcelMappingPerTabDetail" />
  <xs:complexType name="ArrayOfExcelMappingDetail">
    <xs:sequence>
      <xs:element minOccurs="0" maxOccurs="unbounded" name="ExcelMappingDetail" nillable="true" type="tns:ExcelMappingDetail" />
    </xs:sequence>
  </xs:complexType>
  <xs:element name="ArrayOfExcelMappingDetail" nillable="true" type="tns:ArrayOfExcelMappingDetail" />
  <xs:complexType name="ExcelMappingDetail">
    <xs:sequence>
      <xs:element minOccurs="0" name="AD_ColumnField_Name" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="AD_Column_ID" type="xs:int" />
      <xs:element minOccurs="0" name="AD_Column_Name" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="ExcelColIndex" type="xs:int" />
      <xs:element minOccurs="0" name="ExcelColName" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="IsIdentifier" type="xs:boolean" />
      <xs:element minOccurs="0" name="PrimaryKey" type="xs:int" />
      <xs:element minOccurs="0" name="ToDelete" type="xs:boolean" />
      <xs:element minOccurs="0" name="UniqueKey" type="xs:int" />
    </xs:sequence>
  </xs:complexType>
  <xs:element name="ExcelMappingDetail" nillable="true" type="tns:ExcelMappingDetail" />
  <xs:complexType name="OtherImportInfo">
    <xs:sequence>
      <xs:element minOccurs="0" name="AllTables" nillable="true" type="tns:ArrayOfExcelMappingPerTabDetail" />
      <xs:element minOccurs="0" name="AnyError" nillable="true" type="xs:string" />
      <xs:element xmlns:q4="http://schemas.microsoft.com/2003/10/Serialization/Arrays" minOccurs="0" name="C_Location" nillable="true" type="q4:ArrayOfKeyValueOfintstring" />
    </xs:sequence>
  </xs:complexType>
  <xs:element name="OtherImportInfo" nillable="true" type="tns:OtherImportInfo" />
  <xs:complexType name="CallbackDetail">
    <xs:sequence>
      <xs:element minOccurs="0" name="Error" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="Query" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="Status" nillable="true" type="xs:string" />
    </xs:sequence>
  </xs:complexType>
  <xs:element name="CallbackDetail" nillable="true" type="tns:CallbackDetail" />
</xs:schema>